Release 10.1A: OpenEdge Data Management:
SQL Reference

INSERT

Returns a character string where length number of characters have been deleted from string_exp1 beginning at start_pos, and string_exp2 has been inserted into string_exp1, beginning at start_pos.

Syntax

INSERT( string_exp1 , start_pos , length , string_exp2 )

Example

This example illustrates the INSERT function:

SELECT INSERT(last_name,2,4,'xx') FROM customer WHERE last_name = 'Goldman'; INSERT LAST_NAME,2,4,XX) ------------------------ Gxxan 1 record selected

The two letters ‘o’ and ‘l’ are deleted from the name ‘Goldman’ in the last_name column, and the letters ‘xx’ are inserted into the last_name column, beginning at the fourth character, overlaying the letters ‘d’ and ‘m’.

Notes

The string_exp can be type fixed-length or variable-length CHARACTER.
The start_pos and length can be of data type INTEGER, SMALLINT, or TINYINT.
The result string is of the type string_exp1.
If any of the argument expressions evaluate to NULL, the result is NULL.
If start_pos is negative or zero, the result string evaluates to NULL.
If length is negative, the result evaluates to NULL.
string_exp1 and string_exp2 and the result can contain multi-byte characters. This is determined by the character set of the SQL server. The length argument specifies a number of characters.

Compatibility

ODBC compatible